Work in progress: performance regression tracking

Note:

Solution

data.table

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 3.7 3.3 0% 3.4 1%
2 4.7 4.3 6% 4.0 11%
3 5.2 5.9 -8% 4.9 -4%
4 6.4 6.1 -6% 6.1 -1%
5 6.2 5.7 0% 5.3 9%
6 49.6 46.4 0%
7 39.4 37.0 0%
8 90.8 82.1 4%
9 14.7 16.7 -12% 26.1 -27%
10 72.5 67.9 0% 66.1 -3%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.6 0.6 -7%
1e8 6.1 6.2 -2%
1e9 81.2 75.8 4%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 29.3 27.6 -1%
1e1 93.4 95.6 0%
2e0 62.8 61.1 1%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 29.3 27.6 -1%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 29.3 27.6 -1%
1 22.5 23.0 -2%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.1 -14% 0.1 -12%
1 1e8 1.0 0.9 4% 0.9 10%
1 1e9 10.0 8.9 11% 9.3 7%
2 1e7 0.1 0.1 9% 0.1 18%
2 1e8 1.0 1.0 0% 1.0 -1%
2 1e9 13.1 11.9 9% 11.1 18%
3 1e7 0.1 0.1 -3% 0.1 -8%
3 1e8 1.2 1.3 -11% 1.3 -14%
3 1e9 14.4 16.2 -11% 13.2 9%
4 1e7 0.2 0.2 -21% 0.2 -9%
4 1e8 1.5 1.5 -3% 1.5 -2%
4 1e9 17.7 16.6 6% 16.6 6%
5 1e7 0.1 0.2 -16% 0.2 -3%
5 1e8 1.5 1.5 4% 1.3 16%
5 1e9 16.9 15.3 9% 14.5 16%
6 1e7 1.1 1.1 -6%
6 1e8 11.8 11.7 0%
6 1e9 135.9 126.4 7%
7 1e7 0.6 0.6 -7%
7 1e8 7.1 7.2 0%
7 1e9 110.4 103.2 7%
8 1e7 1.5 1.5 1%
8 1e8 16.5 16.3 1%
8 1e9 254.3 228.6 11%
9 1e7 0.8 0.9 -14% 0.8 1%
9 1e8 3.3 3.7 -11% 5.5 -39%
9 1e9 40.2 45.6 -11% 72.2 -44%
10 1e7 1.5 1.6 -6% 1.8 -18%
10 1e8 16.5 17.3 -4% 17.0 -3%
10 1e9 199.6 184.9 7% 179.5 11%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 3.7 3.3 0% 3.4 1%
1 1e1 4.7 4.3 -1% 4.4 8%
1 2e0 5.2 5.2 0% 4.7 8%
2 1e2 4.7 4.3 6% 4.0 11%
2 1e1 5.3 5.5 -3% 4.4 4%
2 2e0 6.1 6.3 1% 6.1 21%
3 1e2 5.2 5.9 -8% 4.9 -4%
3 1e1 10.9 11.1 0% 10.9 -1%
3 2e0 218.0 214.4 6%
4 1e2 6.4 6.1 -6% 6.1 -1%
4 1e1 9.0 8.3 0% 7.5 13%
4 2e0 1.3 1.4 -5% 1.3 -2%
5 1e2 6.2 5.7 0% 5.3 9%
5 1e1 11.8 11.7 2% 10.4 11%
5 2e0 4.0 3.8 5% 3.5 3%
6 1e2 49.6 46.4 0%
6 1e1 37.5 37.5 0%
6 2e0 3.0 2.7 17%
7 1e2 39.4 37.0 0%
7 1e1 154.8 161.6 -2%
7 2e0 68.0 64.6 2%
8 1e2 90.8 82.1 4%
8 1e1 567.5 583.6 -2%
8 2e0 290.7 279.4 1%
9 1e2 14.7 16.7 -12% 26.1 -27%
9 1e1 12.1 12.2 -1% 17.9 -36%
9 2e0 1.4 1.5 -11% 2.0 -28%
10 1e2 72.5 67.9 0% 66.1 -3%
10 1e1 120.4 120.7 3% 117.8 11%
10 2e0 9.6 10.0 -3% 12.6 -40%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 0.6 0.6 -7%
1e2 1e8 6.1 6.2 -2%
1e2 1e9 81.2 75.8 4%
1e1 1e7 1.8 1.8 -4%
1e1 1e8 21.3 21.3 2%
1e1 1e9 257.1 263.8 0%
2e0 1e7 7.9 8.0 2%
2e0 1e8 71.6 68.2 1%
2e0 1e9 216.4 214.5 0%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 3.7 3.3 0% 3.4 1%
1e2 2 4.7 4.3 6% 4.0 11%
1e2 3 5.2 5.9 -8% 4.9 -4%
1e2 4 6.4 6.1 -6% 6.1 -1%
1e2 5 6.2 5.7 0% 5.3 9%
1e2 6 49.6 46.4 0%
1e2 7 39.4 37.0 0%
1e2 8 90.8 82.1 4%
1e2 9 14.7 16.7 -12% 26.1 -27%
1e2 10 72.5 67.9 0% 66.1 -3%
1e1 1 4.7 4.3 -1% 4.4 8%
1e1 2 5.3 5.5 -3% 4.4 4%
1e1 3 10.9 11.1 0% 10.9 -1%
1e1 4 9.0 8.3 0% 7.5 13%
1e1 5 11.8 11.7 2% 10.4 11%
1e1 6 37.5 37.5 0%
1e1 7 154.8 161.6 -2%
1e1 8 567.5 583.6 -2%
1e1 9 12.1 12.2 -1% 17.9 -36%
1e1 10 120.4 120.7 3% 117.8 11%
2e0 1 5.2 5.2 0% 4.7 8%
2e0 2 6.1 6.3 1% 6.1 21%
2e0 3 218.0 214.4 6%
2e0 4 1.3 1.4 -5% 1.3 -2%
2e0 5 4.0 3.8 5% 3.5 3%
2e0 6 3.0 2.7 17%
2e0 7 68.0 64.6 2%
2e0 8 290.7 279.4 1%
2e0 9 1.4 1.5 -11% 2.0 -28%
2e0 10 9.6 10.0 -3% 12.6 -40%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.6 0.6 -7%
0 1e8 6.1 6.2 -2%
0 1e9 81.2 75.8 4%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.6 0.6 -7%
0 1e8 6.1 6.2 -2%
0 1e9 81.2 75.8 4%
1 1e7 0.5 0.5 -4%
1 1e8 5.1 5.1 -2%
1 1e9 61.9 63.4 -1%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 2.6 2.4 11%
2 2.2 2.0 7%
3 4.1 4.3 -4%
4 2.2 2.0 7%
5 13.7 13.8 -8%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.8 0.9 1%
1e8 9.0 8.9 4%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 4.9 4.9 2%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 4.9 4.9 2%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.4 0.3 19%
1 1e8 4.8 4.6 4%
2 1e7 0.4 0.4 3%
2 1e8 4.0 3.7 10%
3 1e7 0.7 0.7 -4%
3 1e8 7.4 7.8 -4%
4 1e7 0.4 0.3 5%
4 1e8 4.0 3.6 8%
5 1e7 2.4 2.9 -17%
5 1e8 25.0 24.6 1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.8 0.9 1%
0 1e8 9.0 8.9 4%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.8 0.9 1%
0 1e8 9.0 8.9 4%

dplyr

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 8.3
2 24.0
3 88.0
4 32.5
5 192.9
6 7.2 7.3 1% 7.4 0%
7 13.2 13.2 2% 13.2 2%
8 28.1 28.4 0% 28.7 -1%
9 50.4
10 897.2 1010.8 -7% 1045.7 -8%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 17.1 17.6 -3% 17.4 0%
1e8 181.8 204.3 -3% 211.4 -3%
1e9 183.4
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2
1e1
2e0 142.2 146.0 -2% 144.2 0%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
1
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.3 0.4 -18% 0.3 -1% 0.3 26%
1 1e8 3.3 3.5 -6% 3.4 -2% 2.2 51%
1 1e9 22.6
2 1e7 0.8 0.9 -5% 0.9 -5% 0.5 65%
2 1e8 9.1 9.3 -2% 9.4 -3% 6.3 44%
2 1e9 65.1
3 1e7 1.8 1.9 -3% 1.7 2% 0.7 138%
3 1e8 30.3 30.6 0% 30.5 0% 16.6 82%
3 1e9 246.5
4 1e7 0.5 0.6 -7% 0.5 -2% 0.6 -7%
4 1e8 6.0 6.6 -9% 6.2 -4% 8.2 -27%
4 1e9 88.7
5 1e7 1.5 1.5 -2% 1.5 0% 1.5 -2%
5 1e8 30.9 31.6 -2% 30.7 0% 38.4 -19%
5 1e9 538.8
6 1e7 1.6 1.6 4% 1.6 4%
6 1e8 12.8 13.0 -2% 13.2 -3%
7 1e7 1.1 1.1 4% 1.1 5%
7 1e8 25.2 25.3 0% 25.4 0%
8 1e7 3.8 3.9 0% 3.9 -1%
8 1e8 52.4 53.0 -1% 53.4 -1%
9 1e7 1.3 1.3 0% 1.4 -6% 1.3 -2%
9 1e8 11.5 11.4 1% 11.6 0% 10.8 7%
9 1e9 139.0
10 1e7 158.3 163.1 -2% 161.1 -1%
10 1e8 1636.1 1858.5 -11% 1930.4 -15%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 8.3
1 1e1 10.3 10.5 2% 10.4 -1% 6.3 100%
1 2e0 7.9 8.8 -4% 8.4 -3% 4.5 92%
2 1e2 24.0
2 1e1 11.0
2 2e0 12.7 12.2 0% 12.4 0% 7.6 78%
3 1e2 88.0
3 1e1 173.4
3 2e0 272.4 282.2 -3% 274.0 -1% 40.3 577%
4 1e2 32.5
4 1e1 19.2
4 2e0 1.6 1.8 0% 1.4 14% 1.6 5%
5 1e2 192.9
5 1e1 472.9
5 2e0 293.7 302.8 -3% 300.0 -1% 85.7 223%
6 1e2 7.2 7.3 1% 7.4 0%
6 1e1 3.9 3.8 3% 4.1 -3%
6 2e0 3.2 3.5 -6% 3.4 0%
7 1e2 13.2 13.2 2% 13.2 2%
7 1e1 51.6 49.6 1% 50.8 1%
7 2e0 188.7 194.4 -2% 187.8 2%
8 1e2 28.1 28.4 0% 28.7 -1%
8 1e1 148.2 161.5 -5% 166.5 -6%
8 2e0 608.5 618.1 -3% 620.0 -2%
9 1e2 50.4
9 1e1 3.7 3.7 5% 3.8 2% 3.2 21%
9 2e0 2.7 2.9 -3% 2.5 4% 2.0 28%
10 1e2 897.2 1010.8 -7% 1045.7 -8%
10 1e1 1098.2 1008.2 3% 1087.0 0%
10 2e0 181.3 191.0 -5% 187.8 -3%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 17.1 17.6 -3% 17.4 0%
1e2 1e8 181.8 204.3 -3% 211.4 -3%
1e2 1e9 183.4
1e1 1e7 22.2 22.8 0% 22.7 -1%
1e1 1e8 271.1 253.0 4% 271.0 0%
1e1 1e9 381.7
2e0 1e7 39.9 41.7 -2% 40.9 1%
2e0 1e8 281.2 288.0 -3% 284.9 0%
2e0 1e9 27.7 28.3 -3% 28.0 -1% 16.4 70%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 8.3
1e2 2 24.0
1e2 3 88.0
1e2 4 32.5
1e2 5 192.9
1e2 6 7.2 7.3 1% 7.4 0%
1e2 7 13.2 13.2 2% 13.2 2%
1e2 8 28.1 28.4 0% 28.7 -1%
1e2 9 50.4
1e2 10 897.2 1010.8 -7% 1045.7 -8%
1e1 1 10.3 10.5 2% 10.4 -1% 6.3 100%
1e1 2 11.0
1e1 3 173.4
1e1 4 19.2
1e1 5 472.9
1e1 6 3.9 3.8 3% 4.1 -3%
1e1 7 51.6 49.6 1% 50.8 1%
1e1 8 148.2 161.5 -5% 166.5 -6%
1e1 9 3.7 3.7 5% 3.8 2% 3.2 21%
1e1 10 1098.2 1008.2 3% 1087.0 0%
2e0 1 7.9 8.8 -4% 8.4 -3% 4.5 92%
2e0 2 12.7 12.2 0% 12.4 0% 7.6 78%
2e0 3 272.4 282.2 -3% 274.0 -1% 40.3 577%
2e0 4 1.6 1.8 0% 1.4 14% 1.6 5%
2e0 5 293.7 302.8 -3% 300.0 -1% 85.7 223%
2e0 6 3.2 3.5 -6% 3.4 0%
2e0 7 188.7 194.4 -2% 187.8 2%
2e0 8 608.5 618.1 -3% 620.0 -2%
2e0 9 2.7 2.9 -3% 2.5 4% 2.0 28%
2e0 10 181.3 191.0 -5% 187.8 -3%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 17.1 17.6 -3% 17.4 0%
0 1e8 181.8 204.3 -3% 211.4 -3%
0 1e9 183.4
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 17.1 17.6 -3% 17.4 0%
0 1e8 181.8 204.3 -3% 211.4 -3%
0 1e9 183.4
1 1e7 15.0 15.0 -3% 15.7 -3%
1 1e8 167.2 169.6 0% 177.3 -3%
1 1e9 149.2

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 9.0 9.0 1% 9.1 1%
2 8.5 8.3 -1% 8.2 4%
3 10.1 10.0 0% 10.0 0%
4 8.8 8.6 3% 8.8 0%
5 93.6 92.5 1% 93.6 0%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 3.7 3.6 0% 3.6 1%
1e8 48.4 47.7 1% 48.3 0%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 26.0 25.7 1% 25.9 1%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 26.0 25.7 1% 25.9 1%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 1.6 1.5 1% 1.5 3%
1 1e8 16.5 16.4 0% 16.7 0%
2 1e7 1.3 1.4 -7% 1.2 4%
2 1e8 15.8 15.1 4% 15.2 3%
3 1e7 1.5 1.5 0% 1.5 0%
3 1e8 18.6 18.4 0% 18.5 0%
4 1e7 1.3 1.3 5% 1.3 0%
4 1e8 16.4 16.0 2% 16.2 1%
5 1e7 12.6 12.4 1% 12.4 1%
5 1e8 174.7 172.6 1% 174.9 0%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 3.7 3.6 0% 3.6 1%
0 1e8 48.4 47.7 1% 48.3 0%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 3.7 3.6 0% 3.6 1%
0 1e8 48.4 47.7 1% 48.3 0%

pandas

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 2.5 2.5 5% 2.4 8% 1.4 75%
2 6.5 6.6 -2% 6.5 0% 3.7 71%
3 6.7 7.2 -4% 7.1 -4% 3.7 83%
4 2.9 2.9 1% 3.0 0% 3.2 -1%
5 7.7 8.2 -2% 7.9 -1% 7.1 4%
6 8.6 9.0 -3% 8.8 -1%
7 6.5 6.7 -7% 6.4 1%
8 26.0 26.4 0% 25.8 0%
9 27.3 28.3 -3% 27.2 0% 29.0 -9%
10 122.5 125.6 -2% 122.5 0%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 3.2 3.3 -1% 3.2 1%
1e8 40.2 41.3 -2% 40.3 0%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 21.7 22.3 -2% 21.8 0%
1e1 20.9 20.8 1% 20.9 1%
2e0 34.9 34.4 0% 34.7 0%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 21.7 22.3 -2% 21.8 0%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 21.7 22.3 -2% 21.8 0%
1 16.0 15.9 0% 16.1 -1%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.5 0.5 11% 0.5 13% 0.3 66%
1 1e8 4.4 4.5 -1% 4.3 3% 2.4 84%
2 1e7 1.1 1.1 -1% 1.1 0% 0.7 66%
2 1e8 11.8 12.1 -2% 11.8 0% 6.7 76%
3 1e7 1.0 1.0 -1% 1.0 -2% 0.5 82%
3 1e8 12.5 13.4 -6% 13.3 -5% 6.8 83%
4 1e7 0.6 0.6 1% 0.6 1% 0.5 7%
4 1e8 5.3 5.2 2% 5.4 -1% 5.9 -10%
5 1e7 0.9 0.9 0% 0.9 0% 0.9 0%
5 1e8 14.5 15.4 -5% 14.9 -3% 13.2 9%
6 1e7 1.5 1.5 -2% 1.5 0%
6 1e8 15.7 16.5 -5% 16.0 -2%
7 1e7 0.9 1.0 -12% 0.9 1%
7 1e8 12.0 12.3 -2% 11.9 1%
8 1e7 3.6 3.6 0% 3.5 0%
8 1e8 48.5 49.2 -1% 48.0 0%
9 1e7 10.6 11.0 -3% 10.5 0% 12.8 -17%
9 1e8 44.0 45.7 -3% 43.9 0% 45.1 -2%
10 1e7 11.6 12.0 -3% 11.7 0%
10 1e8 233.4 239.2 -2% 233.3 0%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 2.5 2.5 5% 2.4 8% 1.4 75%
1 1e1 2.4 2.4 2% 2.4 2% 1.2 109%
1 2e0 2.0 2.0 0% 2.0 1% 1.2 79%
2 1e2 6.5 6.6 -2% 6.5 0% 3.7 71%
2 1e1 5.9 5.8 0% 5.6 2% 3.0 91%
2 2e0 5.1 5.1 0% 5.0 1% 3.0 63%
3 1e2 6.7 7.2 -4% 7.1 -4% 3.7 83%
3 1e1 20.3 20.3 3% 20.4 0% 8.6 158%
3 2e0 57.8 56.2 0% 56.7 0% 14.6 289%
4 1e2 2.9 2.9 1% 3.0 0% 3.2 -1%
4 1e1 3.0 2.9 5% 2.9 4% 3.3 -6%
4 2e0 3.0 2.8 4% 2.9 1% 3.4 -9%
5 1e2 7.7 8.2 -2% 7.9 -1% 7.1 4%
5 1e1 15.7 15.8 -1% 15.8 -3% 16.0 0%
5 2e0 31.8 31.7 0% 32.0 -2% 32.5 -3%
6 1e2 8.6 9.0 -3% 8.8 -1%
6 1e1 6.3 6.4 0% 6.3 0%
6 2e0 5.7 5.8 0% 5.8 -3%
7 1e2 6.5 6.7 -7% 6.4 1%
7 1e1 18.8 18.8 1% 18.6 2%
7 2e0 55.6 54.6 0% 55.2 -1%
8 1e2 26.0 26.4 0% 25.8 0%
8 1e1 32.9 33.1 0% 32.7 1%
8 2e0 49.6 48.8 0% 48.8 0%
9 1e2 27.3 28.3 -3% 27.2 0% 29.0 -9%
9 1e1 17.0 16.9 0% 17.0 1% 15.4 8%
9 2e0 13.2 12.8 2% 12.9 1% 11.6 13%
10 1e2 122.5 125.6 -2% 122.5 0%
10 1e1 87.1 85.2 1% 87.6 -1%
10 2e0 125.2 124.6 0% 125.5 -1%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 3.2 3.3 -1% 3.2 1%
1e2 1e8 40.2 41.3 -2% 40.3 0%
1e1 1e7 2.9 2.9 2% 2.9 1%
1e1 1e8 38.9 38.6 0% 38.9 1%
2e0 1e7 5.1 5.2 0% 5.2 -1%
2e0 1e8 64.7 63.7 1% 64.1 1%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 2.5 2.5 5% 2.4 8% 1.4 75%
1e2 2 6.5 6.6 -2% 6.5 0% 3.7 71%
1e2 3 6.7 7.2 -4% 7.1 -4% 3.7 83%
1e2 4 2.9 2.9 1% 3.0 0% 3.2 -1%
1e2 5 7.7 8.2 -2% 7.9 -1% 7.1 4%
1e2 6 8.6 9.0 -3% 8.8 -1%
1e2 7 6.5 6.7 -7% 6.4 1%
1e2 8 26.0 26.4 0% 25.8 0%
1e2 9 27.3 28.3 -3% 27.2 0% 29.0 -9%
1e2 10 122.5 125.6 -2% 122.5 0%
1e1 1 2.4 2.4 2% 2.4 2% 1.2 109%
1e1 2 5.9 5.8 0% 5.6 2% 3.0 91%
1e1 3 20.3 20.3 3% 20.4 0% 8.6 158%
1e1 4 3.0 2.9 5% 2.9 4% 3.3 -6%
1e1 5 15.7 15.8 -1% 15.8 -3% 16.0 0%
1e1 6 6.3 6.4 0% 6.3 0%
1e1 7 18.8 18.8 1% 18.6 2%
1e1 8 32.9 33.1 0% 32.7 1%
1e1 9 17.0 16.9 0% 17.0 1% 15.4 8%
1e1 10 87.1 85.2 1% 87.6 -1%
2e0 1 2.0 2.0 0% 2.0 1% 1.2 79%
2e0 2 5.1 5.1 0% 5.0 1% 3.0 63%
2e0 3 57.8 56.2 0% 56.7 0% 14.6 289%
2e0 4 3.0 2.8 4% 2.9 1% 3.4 -9%
2e0 5 31.8 31.7 0% 32.0 -2% 32.5 -3%
2e0 6 5.7 5.8 0% 5.8 -3%
2e0 7 55.6 54.6 0% 55.2 -1%
2e0 8 49.6 48.8 0% 48.8 0%
2e0 9 13.2 12.8 2% 12.9 1% 11.6 13%
2e0 10 125.2 124.6 0% 125.5 -1%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 3.2 3.3 -1% 3.2 1%
0 1e8 40.2 41.3 -2% 40.3 0%
Sortedness
by Sortedness (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 3.2 3.3 -1% 3.2 1%
0 1e8 40.2 41.3 -2% 40.3 0%
1 1e7 2.8 2.9 -1% 2.8 -1%
1 1e8 29.2 29.0 1% 29.3 0%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 10.7 10.3 0% 10.3 1%
2 16.0 15.7 1% 15.7 3%
3 19.7 19.9 -4% 19.7 -1%
4 29.3 29.2 0% 29.2 0%
5 61.8 62.8 -1% 62.4 0%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 4.0 4.1 -1% 4.0 0%
1e8 51.0 51.1 0% 50.9 1%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 27.5 27.6 0% 27.5 0%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 27.5 27.6 0% 27.5 0%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 1.5 1.6 -2% 1.6 -1%
1 1e8 19.8 19.1 3% 19.0 3%
2 1e7 2.4 2.4 1% 2.3 4%
2 1e8 29.6 29.0 1% 29.0 1%
3 1e7 3.0 3.2 -8% 3.0 -2%
3 1e8 36.4 36.6 0% 36.3 0%
4 1e7 4.3 4.2 1% 4.3 0%
4 1e8 54.3 54.2 0% 54.2 0%
5 1e7 8.9 9.0 -1% 9.0 0%
5 1e8 114.7 116.6 -1% 115.9 0%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 4.0 4.1 -1% 4.0 0%
0 1e8 51.0 51.1 0% 50.9 1%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 4.0 4.1 -1% 4.0 0%
0 1e8 51.0 51.1 0% 50.9 1%

pydatatable

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 17.5 15.6 7% 18.7 0% 8.8 94%
2 25.5 24.3 4% 24.6 4% 17.5 46%
3 54.0 55.4 6% 51.5 6% 49.6 18%
4 39.5 37.6 3% 38.7 0% 7.4 355%
5 9.3 9.8 15% 9.6 11% 9.1 21%
6 109.0 107.7 25% 95.3 31%
7 52.9 53.1 7% 54.1 2%
8 117.6 118.1 -1% 103.3 14%
9 8.2 8.0 -10% 8.1 0%
10 349.5 340.1 0% 338.5 0% 285.5 30%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 2.3 2.2 10% 2.2 13%
1e8 27.4 26.2 5% 25.8 5%
1e9 205.3 202.5 1% 194.8 3%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 78.3 77.0 5% 74.2 7%
1e1 75.1 76.5 -2% 74.2 -3%
2e0 125.4 125.1 0% 122.8 0%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 78.3 77.0 5% 74.2 7%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 78.3 77.0 5% 74.2 7%
1 61.5 62.4 0% 56.1 4%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.4 0.4 -8% 0.4 -3% 0.2 97%
1 1e8 5.0 4.1 20% 4.5 10% 2.7 83%
1 1e9 47.2 42.2 11% 51.1 -7% 23.5 100%
2 1e7 0.6 0.6 -1% 0.5 5% 0.5 28%
2 1e8 7.4 6.7 11% 7.0 5% 4.4 66%
2 1e9 68.5 65.7 4% 66.3 3% 47.6 43%
3 1e7 1.3 1.2 8% 1.2 2% 1.1 15%
3 1e8 13.7 12.0 14% 12.2 12% 10.4 32%
3 1e9 147.1 153.2 -3% 141.1 4% 137.2 7%
4 1e7 0.9 0.9 -2% 1.0 -11% 0.3 191%
4 1e8 10.8 9.9 8% 10.0 7% 2.0 435%
4 1e9 106.8 102.1 4% 105.2 1% 19.9 438%
5 1e7 0.5 0.3 58% 0.3 48% 0.3 67%
5 1e8 3.3 3.7 -8% 3.8 -11% 3.6 -6%
5 1e9 24.2 25.3 -4% 24.7 -2% 23.3 3%
6 1e7 2.4 1.4 68% 1.4 68%
6 1e8 82.9 76.0 9% 75.4 9%
6 1e9 241.6 245.7 -1% 209.1 15%
7 1e7 1.3 1.1 21% 1.2 6%
7 1e8 12.3 12.2 0% 11.9 3%
7 1e9 145.1 146.1 0% 149.2 -2%
8 1e7 3.2 3.5 -7% 2.8 13%
8 1e8 33.9 33.1 2% 29.3 15%
8 1e9 315.8 317.8 0% 277.6 13%
9 1e7 0.2 0.3 -33% 0.2 5%
9 1e8 2.1 2.1 0% 2.2 -3%
9 1e9 22.2 21.4 3% 21.9 1%
10 1e7 12.1 12.3 -1% 12.5 -3% 8.8 37%
10 1e8 102.3 102.6 0% 101.6 0% 77.5 32%
10 1e9 934.2 905.3 3% 901.5 3% 770.1 21%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 17.5 15.6 7% 18.7 0% 8.8 94%
1 1e1 8.8 8.5 1% 8.7 6% 4.8 83%
1 2e0 8.1 8.0 0% 9.0 -2% 4.9 50%
2 1e2 25.5 24.3 4% 24.6 4% 17.5 46%
2 1e1 22.3 21.4 -4% 22.5 -4% 13.7 77%
2 2e0 13.2 14.0 -4% 13.8 -5% 6.2 93%
3 1e2 54.0 55.4 6% 51.5 6% 49.6 18%
3 1e1 123.8 131.1 -6% 121.6 -6% 117.6 9%
3 2e0 338.3 336.2 1% 325.5 3% 227.7 56%
4 1e2 39.5 37.6 3% 38.7 0% 7.4 355%
4 1e1 13.6 14.3 0% 14.3 -2% 3.9 215%
4 2e0 11.6 11.7 -1% 11.2 0% 7.2 55%
5 1e2 9.3 9.8 15% 9.6 11% 9.1 21%
5 1e1 44.6 45.6 -4% 45.2 -1% 57.7 -31%
5 2e0 26.4 26.1 3% 25.6 9% 47.5 -44%
6 1e2 109.0 107.7 25% 95.3 31%
6 1e1 29.2 29.1 2% 29.6 4%
6 2e0 12.6 12.2 0% 12.4 -2%
7 1e2 52.9 53.1 7% 54.1 2%
7 1e1 119.3 124.4 -3% 117.0 0%
7 2e0 316.0 317.2 -3% 312.3 -2%
8 1e2 117.6 118.1 -1% 103.3 14%
8 1e1 43.8 43.2 -2% 43.7 -5%
8 2e0 27.9 27.2 4% 27.0 8%
9 1e2 8.2 8.0 -10% 8.1 0%
9 1e1 10.2 10.2 -6% 10.3 -20%
9 2e0 8.3 8.5 -6% 8.3 -1%
10 1e2 349.5 340.1 0% 338.5 0% 285.5 30%
10 1e1 336.1 337.1 0% 329.3 0% 268.4 23%
10 2e0 491.8 489.8 -1% 482.8 -1% 299.1 64%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 2.3 2.2 10% 2.2 13%
1e2 1e8 27.4 26.2 5% 25.8 5%
1e2 1e9 205.3 202.5 1% 194.8 3%
1e1 1e7 1.8 1.8 -2% 1.8 -5%
1e1 1e8 17.4 17.9 -3% 18.3 -4%
1e1 1e9 206.2 209.8 0% 202.5 0%
2e0 1e7 3.2 3.2 -1% 3.2 1%
2e0 1e8 31.9 32.5 -1% 32.5 0%
2e0 1e9 341.2 339.6 0% 332.6 0%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 17.5 15.6 7% 18.7 0% 8.8 94%
1e2 2 25.5 24.3 4% 24.6 4% 17.5 46%
1e2 3 54.0 55.4 6% 51.5 6% 49.6 18%
1e2 4 39.5 37.6 3% 38.7 0% 7.4 355%
1e2 5 9.3 9.8 15% 9.6 11% 9.1 21%
1e2 6 109.0 107.7 25% 95.3 31%
1e2 7 52.9 53.1 7% 54.1 2%
1e2 8 117.6 118.1 -1% 103.3 14%
1e2 9 8.2 8.0 -10% 8.1 0%
1e2 10 349.5 340.1 0% 338.5 0% 285.5 30%
1e1 1 8.8 8.5 1% 8.7 6% 4.8 83%
1e1 2 22.3 21.4 -4% 22.5 -4% 13.7 77%
1e1 3 123.8 131.1 -6% 121.6 -6% 117.6 9%
1e1 4 13.6 14.3 0% 14.3 -2% 3.9 215%
1e1 5 44.6 45.6 -4% 45.2 -1% 57.7 -31%
1e1 6 29.2 29.1 2% 29.6 4%
1e1 7 119.3 124.4 -3% 117.0 0%
1e1 8 43.8 43.2 -2% 43.7 -5%
1e1 9 10.2 10.2 -6% 10.3 -20%
1e1 10 336.1 337.1 0% 329.3 0% 268.4 23%
2e0 1 8.1 8.0 0% 9.0 -2% 4.9 50%
2e0 2 13.2 14.0 -4% 13.8 -5% 6.2 93%
2e0 3 338.3 336.2 1% 325.5 3% 227.7 56%
2e0 4 11.6 11.7 -1% 11.2 0% 7.2 55%
2e0 5 26.4 26.1 3% 25.6 9% 47.5 -44%
2e0 6 12.6 12.2 0% 12.4 -2%
2e0 7 316.0 317.2 -3% 312.3 -2%
2e0 8 27.9 27.2 4% 27.0 8%
2e0 9 8.3 8.5 -6% 8.3 -1%
2e0 10 491.8 489.8 -1% 482.8 -1% 299.1 64%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.3 2.2 10% 2.2 13%
0 1e8 27.4 26.2 5% 25.8 5%
0 1e9 205.3 202.5 1% 194.8 3%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.3 2.2 10% 2.2 13%
0 1e8 27.4 26.2 5% 25.8 5%
0 1e9 205.3 202.5 1% 194.8 3%
1 1e7 1.9 1.9 4% 1.8 4%
1 1e8 24.4 24.8 -1% 20.2 7%
1 1e9 158.3 160.5 -1% 146.2 2%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 269.4 380.6 15% 672.7 -44%
2 299.7 519.2 -6% 926.9 -35%
3 150.8 384.8 0% 510.2 -20%
4 267.7 423.0 28% 795.1 -43%
5 53.0 76.4 8% 239.7 17%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 14.1 11.5 30% 9.2 58%
1e8 45.4 48.5 30% 329.7 -86%
1e9 692.7 1243.9 -44% 1874.9 -63%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 219.2 376.8 9% 656.7 -28%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 219.2 376.8 9% 656.7 -28%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 10.8 10.2 6% 10.0 8%
1 1e8 39.5 23.1 71% 306.3 -87%
1 1e9 757.8 1108.6 -31% 1701.8 -55%
2 1e7 15.9 14.9 6% 10.7 48%
2 1e8 44.2 38.0 16% 388.7 -88%
2 1e9 838.9 1504.6 -44% 2381.2 -64%
3 1e7 10.7 5.6 92% 5.5 96%
3 1e8 17.3 24.5 -29% 181.7 -90%
3 1e9 424.3 1124.3 -62% 1343.4 -68%
4 1e7 12.0 13.2 -8% 10.0 20%
4 1e8 41.2 17.6 134% 302.3 -86%
4 1e9 749.9 1238.1 -39% 2073.0 -63%
5 1e7 21.0 13.4 56% 9.7 116%
5 1e8 85.0 139.4 -39% 469.7 -81%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 14.1 11.5 30% 9.2 58%
0 1e8 45.4 48.5 30% 329.7 -86%
0 1e9 692.7 1243.9 -44% 1874.9 -63%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 14.1 11.5 30% 9.2 58%
0 1e8 45.4 48.5 30% 329.7 -86%
0 1e9 692.7 1243.9 -44% 1874.9 -63%

spark

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 6.1 6.9 -6% 7.1 -18%
2 9.8 9.6 4% 10.0 -12%
3 28.3 29.2 2% 30.6 -2%
4 3.1 3.5 0% 3.4 -12%
5 23.9 23.1 4% 22.6 -7%
7 31.6 28.6 6%
8 57.3 54.6 3%
9 7.8 7.9 0% 9.1 -13%
10 275.0 272.8 -3% 265.3 -7%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 1.9 1.8 9%
1e8 8.0 8.8 -6%
1e9 137.8 134.9 0%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 49.2 48.5 1%
1e1 52.9 48.4 0%
2e0 52.3 48.7 10%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 49.2 48.5 1%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 49.2 48.5 1%
1 42.5 38.9 7%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 2.0 1.6 29% 2.2 -7%
1 1e8 3.1 6.6 -53% 6.6 -53%
1 1e9 13.3 12.6 5% 12.4 7%
2 1e7 1.5 1.2 22% 2.1 -30%
2 1e8 3.5 3.9 -12% 3.8 -9%
2 1e9 24.6 23.7 3% 24.1 1%
3 1e7 1.7 1.6 8% 1.7 0%
3 1e8 6.3 6.1 2% 6.3 0%
3 1e9 76.9 79.9 -3% 83.7 -8%
4 1e7 0.7 0.6 20% 0.9 -13%
4 1e8 1.1 1.1 -2% 1.3 -13%
4 1e9 7.4 8.8 -15% 8.2 -9%
5 1e7 1.3 1.3 1% 1.5 -15%
5 1e8 4.9 4.5 8% 5.7 -13%
5 1e9 65.4 63.6 2% 60.5 8%
7 1e7 1.3 1.3 6%
7 1e8 5.8 5.8 0%
7 1e9 87.8 78.9 11%
8 1e7 2.7 2.5 6%
8 1e8 10.5 10.7 -2%
8 1e9 158.8 150.5 5%
9 1e7 1.1 1.1 -3% 1.3 -19%
9 1e8 2.8 2.6 5% 2.9 -5%
9 1e9 19.5 20.0 -2% 22.9 -15%
10 1e7 4.7 4.8 -3% 5.2 -9%
10 1e8 33.8 37.3 -9% 40.8 -17%
10 1e9 786.4 776.2 1% 750.0 4%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 6.1 6.9 -6% 7.1 -18%
1 1e1 5.5 5.3 4% 5.3 1%
1 2e0 5.4 5.7 4% 5.4 3%
2 1e2 9.8 9.6 4% 10.0 -12%
2 1e1 7.0 6.7 13% 7.4 -13%
2 2e0 6.4 6.2 3% 5.6 9%
3 1e2 28.3 29.2 2% 30.6 -2%
3 1e1 59.4 36.5 16% 47.5 0%
3 2e0 55.4 49.2 14% 52.7 -4%
4 1e2 3.1 3.5 0% 3.4 -12%
4 1e1 3.0 3.1 -10% 3.4 -18%
4 2e0 3.5 3.4 29% 3.3 18%
5 1e2 23.9 23.1 4% 22.6 -7%
5 1e1 32.1 31.9 -15% 31.1 -11%
5 2e0 48.0 42.1 24% 42.3 11%
7 1e2 31.6 28.6 6%
7 1e1 43.6 40.1 -2%
7 2e0 61.5 52.8 10%
8 1e2 57.3 54.6 3%
8 1e1 57.4 52.0 1%
8 2e0 66.5 54.7 7%
9 1e2 7.8 7.9 0% 9.1 -13%
9 1e1 5.2 5.3 10% 5.5 0%
9 2e0 4.9 4.9 -4% 6.5 -25%
10 1e2 275.0 272.8 -3% 265.3 -7%
10 1e1 262.7 254.6 -10% 269.4 -9%
10 2e0 218.6 219.1 3% 211.5 -4%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 1.9 1.8 9%
1e2 1e8 8.0 8.8 -6%
1e2 1e9 137.8 134.9 0%
1e1 1e7 1.9 2.2 -5%
1e1 1e8 8.5 9.5 -3%
1e1 1e9 148.2 133.5 11%
2e0 1e7 2.2 1.9 21%
2e0 1e8 10.7 9.7 2%
2e0 1e9 143.9 134.4 6%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 6.1 6.9 -6% 7.1 -18%
1e2 2 9.8 9.6 4% 10.0 -12%
1e2 3 28.3 29.2 2% 30.6 -2%
1e2 4 3.1 3.5 0% 3.4 -12%
1e2 5 23.9 23.1 4% 22.6 -7%
1e2 7 31.6 28.6 6%
1e2 8 57.3 54.6 3%
1e2 9 7.8 7.9 0% 9.1 -13%
1e2 10 275.0 272.8 -3% 265.3 -7%
1e1 1 5.5 5.3 4% 5.3 1%
1e1 2 7.0 6.7 13% 7.4 -13%
1e1 3 59.4 36.5 16% 47.5 0%
1e1 4 3.0 3.1 -10% 3.4 -18%
1e1 5 32.1 31.9 -15% 31.1 -11%
1e1 7 43.6 40.1 -2%
1e1 8 57.4 52.0 1%
1e1 9 5.2 5.3 10% 5.5 0%
1e1 10 262.7 254.6 -10% 269.4 -9%
2e0 1 5.4 5.7 4% 5.4 3%
2e0 2 6.4 6.2 3% 5.6 9%
2e0 3 55.4 49.2 14% 52.7 -4%
2e0 4 3.5 3.4 29% 3.3 18%
2e0 5 48.0 42.1 24% 42.3 11%
2e0 7 61.5 52.8 10%
2e0 8 66.5 54.7 7%
2e0 9 4.9 4.9 -4% 6.5 -25%
2e0 10 218.6 219.1 3% 211.5 -4%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.9 1.8 9%
0 1e8 8.0 8.8 -6%
0 1e9 137.8 134.9 0%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.9 1.8 9%
0 1e8 8.0 8.8 -6%
0 1e9 137.8 134.9 0%
1 1e7 1.9 1.9 4%
1 1e8 7.5 7.0 2%
1 1e9 118.0 107.7 14%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 293.9 234.7 22%
2 672.7 602.1 26%
3 740.3 645.6 20%
4 617.1
5 45.2 36.8 14%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 5.8 5.4 8%
1e8 51.6 37.5 39%
1e9 1539.3
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 455.1
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 455.1
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 4.2 4.2 1%
1 1e8 37.1 26.2 41%
1 1e9 840.5 673.7 24%
2 1e7 4.4 3.5 25%
2 1e8 46.0 32.3 42%
2 1e9 1967.6 1770.4 11%
3 1e7 4.6 4.4 3%
3 1e8 49.7 34.6 43%
3 1e9 2166.5 1897.8 14%
4 1e7 4.3 4.0 7%
4 1e8 45.7 32.0 43%
4 1e9 1815.3
5 1e7 11.3 11.0 3%
5 1e8 79.2 62.6 26%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 5.8 5.4 8%
0 1e8 51.6 37.5 39%
0 1e9 1539.3
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 5.8 5.4 8%
0 1e8 51.6 37.5 39%
0 1e9 1539.3

cudf

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 0.0 0.1 -66%
2 0.0 0.1 -40%
3 0.1 1.0 -85%
4 0.1 0.3 -52%
5 0.1 0.1 -10%
6 0.5
10 0.5 0.5 3%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.2
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 0.2
1e1 0.2
2e0 0.2
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.2
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.2
1 0.2
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.0 0.1 -66%
2 1e7 0.0 0.1 -40%
3 1e7 0.1 1.0 -85%
4 1e7 0.1 0.3 -52%
5 1e7 0.1 0.1 -10%
6 1e7 0.5
10 1e7 0.5 0.5 3%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 0.0 0.1 -66%
1 1e1 0.0 0.0 -20%
1 2e0 0.0 0.0 -8%
2 1e2 0.0 0.1 -40%
2 1e1 0.0 0.0 17%
2 2e0 0.0 0.0 19%
3 1e2 0.1 1.0 -85%
3 1e1 0.2 0.1 44%
3 2e0 0.2 0.2 -1%
4 1e2 0.1 0.3 -52%
4 1e1 0.1 0.0 112%
4 2e0 0.1 0.1 55%
5 1e2 0.1 0.1 -10%
5 1e1 0.1 0.1 -8%
5 2e0 0.1 0.1 -6%
6 1e2 0.5
6 1e1 0.4
6 2e0 0.3
10 1e2 0.5 0.5 3%
10 1e1 0.6 0.6 3%
10 2e0 0.6 0.7 -3%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 0.2
1e1 1e7 0.2
2e0 1e7 0.2
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 0.0 0.1 -66%
1e2 2 0.0 0.1 -40%
1e2 3 0.1 1.0 -85%
1e2 4 0.1 0.3 -52%
1e2 5 0.1 0.1 -10%
1e2 6 0.5
1e2 10 0.5 0.5 3%
1e1 1 0.0 0.0 -20%
1e1 2 0.0 0.0 17%
1e1 3 0.2 0.1 44%
1e1 4 0.1 0.0 112%
1e1 5 0.1 0.1 -8%
1e1 6 0.4
1e1 10 0.6 0.6 3%
2e0 1 0.0 0.0 -8%
2e0 2 0.0 0.0 19%
2e0 3 0.2 0.2 -1%
2e0 4 0.1 0.1 55%
2e0 5 0.1 0.1 -6%
2e0 6 0.3
2e0 10 0.6 0.7 -3%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.2
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.2
1 1e7 0.2

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 0.1 0.0 103%
2 0.0 0.0 -2%
3 0.0 0.0 0%
4 0.0 0.0 0%
5 0.2 0.2 1%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.1 0.1 20%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.1 0.1 20%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.1 0.1 20%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.0 103%
2 1e7 0.0 0.0 -2%
3 1e7 0.0 0.0 0%
4 1e7 0.0 0.0 0%
5 1e7 0.2 0.2 1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.1 0.1 20%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.1 0.1 20%

dask

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 352.6
2 0.9 0.8 22% 0.8 15% 0.9 112%
3 25.4 24.4 8% 25.6 3% 69.0 -24%
4 0.8 0.8 -1% 0.9 -7% 1.0 49%
5 5.1 4.9 -4% 4.9 0% 4.1 93%
7 22.4 21.6 0% 22.7 5%
8 208.2 219.0 -2% 212.4 0%
10 253.8
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 6.2 6.2 5% 6.2 7%
1e8
1e9 1049.4
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2
1e1
2e0
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
1
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.3 0.3 2% 0.2 30% 0.1 118%
1 1e8 8.0 6.9 16% 8.2 -2% 0.6 1152%
1 1e9 1049.4
2 1e7 0.8 0.5 45% 0.6 28% 0.2 261%
2 1e8 1.0 1.0 0% 0.9 3% 1.5 -36%
3 1e7 1.9 1.7 12% 1.7 7% 1.6 15%
3 1e8 49.0 47.2 3% 49.4 0% 136.3 -64%
4 1e7 0.6 0.5 0% 0.7 -16% 0.2 136%
4 1e8 1.1 1.1 -3% 1.1 0% 1.8 -38%
5 1e7 1.0 1.2 -14% 1.0 -1% 0.4 171%
5 1e8 9.2 8.7 5% 8.8 3% 7.9 16%
7 1e7 1.7 1.8 -3% 1.5 13%
7 1e8 43.1 41.3 4% 44.0 -1%
8 1e7 24.2 24.0 0% 24.1 0%
8 1e8 392.3 414.1 -5% 400.6 -2%
10 1e7 19.3 19.5 -1% 20.0 -3% 15.3 26%
10 1e8 492.2
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 352.6
1 1e1 306.5
1 2e0 6.0 6.2 0% 5.7 22% 0.4 947%
2 1e2 0.9 0.8 22% 0.8 15% 0.9 112%
2 1e1 0.5 0.6 -12% 0.5 -10% 0.7 45%
2 2e0 0.6 0.6 -4% 0.5 2% 0.6 81%
3 1e2 25.4 24.4 8% 25.6 3% 69.0 -24%
3 1e1 173.3 173.7 1% 169.4 -1% 245.2 -9%
3 2e0 408.2
4 1e2 0.8 0.8 -1% 0.9 -7% 1.0 49%
4 1e1 4.7 5.2 -8% 2.5 48% 1.1 243%
4 2e0 1.0
5 1e2 5.1 4.9 -4% 4.9 0% 4.1 93%
5 1e1 22.0 21.5 1% 20.2 4% 14.9 95%
5 2e0 35.4
7 1e2 22.4 21.6 0% 22.7 5%
7 1e1 164.3 165.7 -2% 146.6 4%
7 2e0 36.2 36.6 -1% 36.2 0%
8 1e2 208.2 219.0 -2% 212.4 0%
8 1e1 2265.3 1823.3 11% 2249.9 0%
8 2e0 1043.5 1053.0 0% 1028.6 1%
10 1e2 253.8
10 1e1 390.4
10 2e0 636.4
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 6.2 6.2 5% 6.2 7%
1e2 1e8
1e2 1e9 1049.4
1e1 1e7 33.6 34.4 -5% 33.8 0%
1e1 1e8
1e1 1e9 909.3
2e0 1e7 147.3 148.9 -3% 145.7 1%
2e0 1e8 347.5
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 352.6
1e2 2 0.9 0.8 22% 0.8 15% 0.9 112%
1e2 3 25.4 24.4 8% 25.6 3% 69.0 -24%
1e2 4 0.8 0.8 -1% 0.9 -7% 1.0 49%
1e2 5 5.1 4.9 -4% 4.9 0% 4.1 93%
1e2 7 22.4 21.6 0% 22.7 5%
1e2 8 208.2 219.0 -2% 212.4 0%
1e2 10 253.8
1e1 1 306.5
1e1 2 0.5 0.6 -12% 0.5 -10% 0.7 45%
1e1 3 173.3 173.7 1% 169.4 -1% 245.2 -9%
1e1 4 4.7 5.2 -8% 2.5 48% 1.1 243%
1e1 5 22.0 21.5 1% 20.2 4% 14.9 95%
1e1 7 164.3 165.7 -2% 146.6 4%
1e1 8 2265.3 1823.3 11% 2249.9 0%
1e1 10 390.4
2e0 1 6.0 6.2 0% 5.7 22% 0.4 947%
2e0 2 0.6 0.6 -4% 0.5 2% 0.6 81%
2e0 3 408.2
2e0 4 1.0
2e0 5 35.4
2e0 7 36.2 36.6 -1% 36.2 0%
2e0 8 1043.5 1053.0 0% 1028.6 1%
2e0 10 636.4
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 6.2 6.2 5% 6.2 7%
0 1e8
0 1e9 1049.4
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 6.2 6.2 5% 6.2 7%
0 1e8
0 1e9 1049.4
1 1e7 6.0 6.1 -4% 6.0 -4%
1 1e8
1 1e9 970.0

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 104.6 102.8 1% 117.1 -7%
2 119.9 116.8 2% 132.6 -5%
3 111.1 123.9 -4% 127.9 -6%
4 146.5 135.7 5% 147.1 0%
5 211.2 204.9 3% 208.3 1%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 55.6 54.1 2% 55.1 0%
1e8 224.3 223.2 0% 245.6 -9%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 130.6 129.2 1% 139.7 -3%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 130.6 129.2 1% 139.7 -3%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 15.1 14.8 2% 15.7 -3%
1 1e8 194.0 190.7 1% 218.5 -11%
2 1e7 17.0 16.6 2% 17.0 0%
2 1e8 222.8 216.9 2% 248.2 -10%
3 1e7 15.3 14.9 2% 15.2 0%
3 1e8 206.8 232.8 -11% 240.6 -14%
4 1e7 19.6 19.1 2% 19.2 2%
4 1e8 273.4 252.4 8% 275.0 0%
5 1e7 211.2 204.9 3% 208.3 1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 55.6 54.1 2% 55.1 0%
0 1e8 224.3 223.2 0% 245.6 -9%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 55.6 54.1 2% 55.1 0%
0 1e8 224.3 223.2 0% 245.6 -9%

juliadf

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 11.6 12.0 0% 14.3 -13%
2 6.0 5.2 9% 4.1 20%
3 62.4 57.5 3% 58.6 0%
4 14.2 12.2 10% 14.0 5%
5 76.1 70.6 1% 77.7 -5%
6 64.1 70.2 -1% 72.2 -2%
7 152.6 149.0 0% 142.6 3%
8 144.3 151.8 -2% 153.3 -2%
9 98.2 82.4 8% 82.3 9%
10 252.2 243.7 1% 254.9 -2%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 2.0 1.9 2% 1.9 2%
1e8 13.1 13.2 1% 13.9 -3%
1e9 249.4 241.3 5% 246.4 4%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 88.2 85.5 3% 87.4 1%
1e1 11.3 11.3 -2% 11.6 0%
2e0
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 88.2 85.5 3% 87.4 1%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 88.2 85.5 3% 87.4 1%
1 73.4 74.6 0% 80.4 -1%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 6.6 6.3 5% 7.0 -5% 4.8 37%
1 1e8 7.4 7.5 -1% 8.3 -10% 6.2 19%
1 1e9 20.8 22.2 -6% 27.6 -24%
2 1e7 0.3 0.3 1% 0.3 5% 0.6 -44%
2 1e8 1.4 1.2 10% 1.3 6% 4.8 -70%
2 1e9 16.2 14.0 15% 10.8 50%
3 1e7 1.0 1.0 1% 1.1 -3% 1.1 -10%
3 1e8 4.9 4.9 0% 5.0 -2% 14.8 -66%
3 1e9 181.3 166.7 8% 169.8 6%
4 1e7 0.7 0.6 9% 0.6 13% 0.7 0%
4 1e8 3.0 2.9 5% 3.0 2% 3.8 -21%
4 1e9 38.8 33.2 16% 38.3 1%
5 1e7 0.7 0.7 -5% 0.7 -7% 1.1 -40%
5 1e8 8.9 8.8 1% 9.6 -7% 19.0 -53%
5 1e9 218.8 202.4 8% 222.8 -1%
6 1e7 2.6 2.5 3% 2.5 6%
6 1e8 15.6 15.3 1% 15.8 -1%
6 1e9 174.1 192.7 -9% 198.2 -12%
7 1e7 1.6 1.6 0% 1.5 3%
7 1e8 16.9 17.1 0% 17.3 -1%
7 1e9 439.3 428.4 2% 409.1 7%
8 1e7 1.9 1.9 0% 1.9 1%
8 1e8 23.8 24.0 0% 24.6 -3%
8 1e9 407.1 429.6 -5% 433.5 -6%
9 1e7 1.8 1.8 4% 1.7 6% 2.1 -10%
9 1e8 15.9 15.9 0% 15.9 0% 16.1 -1%
9 1e9 276.9 229.5 20% 229.4 20%
10 1e7 2.3 2.3 2% 2.2 5% 3.2 -26%
10 1e8 33.5 34.2 -2% 38.2 -12% 34.0 -1%
10 1e9 720.8 694.6 3% 724.2 0%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 11.6 12.0 0% 14.3 -13%
1 1e1 7.6 7.7 -1% 8.2 -6% 5.8 32%
1 2e0 7.5
2 1e2 6.0 5.2 9% 4.1 20%
2 1e1 0.7 0.8 -10% 0.7 -2% 1.2 -28%
2 2e0 1.1
3 1e2 62.4 57.5 3% 58.6 0%
3 1e1 9.9 9.8 0% 10.1 -1% 17.7 -39%
3 2e0 24.8
4 1e2 14.2 12.2 10% 14.0 5%
4 1e1 1.9 1.8 0% 1.9 7% 2.3 -13%
4 2e0 2.5
5 1e2 76.1 70.6 1% 77.7 -5%
5 1e1 8.2 8.1 -1% 8.5 -6% 16.4 -51%
5 2e0 21.1
6 1e2 64.1 70.2 -1% 72.2 -2%
6 1e1 6.6 6.9 -5% 6.5 3%
6 2e0 2.0 2.0 0% 1.9 4%
7 1e2 152.6 149.0 0% 142.6 3%
7 1e1 18.5 18.5 -1% 18.9 -2%
7 2e0 4.1 4.2 -1% 4.2 -1%
8 1e2 144.3 151.8 -2% 153.3 -2%
8 1e1 29.8 29.5 0% 31.6 -5%
8 2e0 9.6 9.5 1% 9.9 -3%
9 1e2 98.2 82.4 8% 82.3 9%
9 1e1 6.3 6.3 -2% 6.2 4% 6.2 -9%
9 2e0 6.7
10 1e2 252.2 243.7 1% 254.9 -2%
10 1e1 23.8 23.7 -2% 23.4 1% 25.2 -14%
10 2e0 34.5
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 2.0 1.9 2% 1.9 2%
1e2 1e8 13.1 13.2 1% 13.9 -3%
1e2 1e9 249.4 241.3 5% 246.4 4%
1e1 1e7 2.3 2.4 -4% 2.3 1%
1e1 1e8 20.3 20.2 0% 20.9 -2%
2e0 1e7 3.1 3.1 1% 3.2 1%
2e0 1e8 25.0
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 11.6 12.0 0% 14.3 -13%
1e2 2 6.0 5.2 9% 4.1 20%
1e2 3 62.4 57.5 3% 58.6 0%
1e2 4 14.2 12.2 10% 14.0 5%
1e2 5 76.1 70.6 1% 77.7 -5%
1e2 6 64.1 70.2 -1% 72.2 -2%
1e2 7 152.6 149.0 0% 142.6 3%
1e2 8 144.3 151.8 -2% 153.3 -2%
1e2 9 98.2 82.4 8% 82.3 9%
1e2 10 252.2 243.7 1% 254.9 -2%
1e1 1 7.6 7.7 -1% 8.2 -6% 5.8 32%
1e1 2 0.7 0.8 -10% 0.7 -2% 1.2 -28%
1e1 3 9.9 9.8 0% 10.1 -1% 17.7 -39%
1e1 4 1.9 1.8 0% 1.9 7% 2.3 -13%
1e1 5 8.2 8.1 -1% 8.5 -6% 16.4 -51%
1e1 6 6.6 6.9 -5% 6.5 3%
1e1 7 18.5 18.5 -1% 18.9 -2%
1e1 8 29.8 29.5 0% 31.6 -5%
1e1 9 6.3 6.3 -2% 6.2 4% 6.2 -9%
1e1 10 23.8 23.7 -2% 23.4 1% 25.2 -14%
2e0 1 7.5
2e0 2 1.1
2e0 3 24.8
2e0 4 2.5
2e0 5 21.1
2e0 6 2.0 2.0 0% 1.9 4%
2e0 7 4.1 4.2 -1% 4.2 -1%
2e0 8 9.6 9.5 1% 9.9 -3%
2e0 9 6.7
2e0 10 34.5
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.0 1.9 2% 1.9 2%
0 1e8 13.1 13.2 1% 13.9 -3%
0 1e9 249.4 241.3 5% 246.4 4%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.0 1.9 2% 1.9 2%
0 1e8 13.1 13.2 1% 13.9 -3%
0 1e9 249.4 241.3 5% 246.4 4%
1 1e7 1.9 1.9 2% 2.0 0%
1 1e8 12.1 12.7 -3% 12.6 -2%
1 1e9 206.2 209.3 0% 226.5 -3%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 231.3 232.0 -3% 230.3 -1%
2 257.8 258.4 -3% 253.1 5%
3 305.9 307.1 -3% 284.7 6%
4 263.5 265.8 -4% 259.4 5%
5 461.5 464.0 -1% 457.1 1%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 16.5 17.5 -6% 15.8 4%
1e8 591.6 593.4 0% 578.0 2%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 304.0 305.4 -3% 296.9 3%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 304.0 305.4 -3% 296.9 3%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 14.1 15.0 -5% 14.5 -2%
1 1e8 448.5 449.0 0% 446.2 0%
2 1e7 12.2 13.2 -7% 11.2 8%
2 1e8 503.4 503.7 0% 494.9 1%
3 1e7 17.2 18.5 -6% 16.2 6%
3 1e8 594.6 595.6 0% 553.2 7%
4 1e7 12.5 13.6 -8% 11.4 9%
4 1e8 514.5 518.1 0% 507.4 1%
5 1e7 26.4 27.3 -3% 25.7 2%
5 1e8 896.7 900.7 0% 888.4 0%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 16.5 17.5 -6% 15.8 4%
0 1e8 591.6 593.4 0% 578.0 2%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 16.5 17.5 -6% 15.8 4%
0 1e8 591.6 593.4 0% 578.0 2%

clickhouse

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 8.1 36.9 276% 85.1 250% 15.4 186%
2 4.5 4.5 51% 3.4 58% 7.4 38%
3 23.1 14.4 29% 7.2 72% 33.4 -22%
4 11.6 11.0 41% 17.2 33% 20.2 11%
5 6.3 5.6 15% 10.9 -3% 13.6 -21%
6 7.7 7.8 6% 15.6 -29%
7 5.6 5.9 5% 19.0 -39%
8 45.0 35.5 10% 44.4 -2%
9 34.8 34.2 39% 37.0 38%
10 503.2
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.5 0.3 25% 0.4 -1%
1e8 4.1 2.6 133% 3.1 126%
1e9 190.5
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 65.0
1e1 90.8
2e0 99.4
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 65.0
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 65.0
1 56.1
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.1 2% 0.1 -42% 0.1 10%
1 1e8 2.8 0.3 906% 0.3 884% 0.4 600%
1 1e9 21.5 110.4 -80% 254.9 -91% 45.8 -52%
2 1e7 0.2 0.1 7% 0.1 15% 0.1 21%
2 1e8 2.2 0.9 157% 0.9 136% 0.9 140%
2 1e9 11.0 12.5 -11% 9.0 22% 21.1 -47%
3 1e7 0.2 0.1 20% 0.2 -25% 0.2 -2%
3 1e8 1.2 1.2 4% 1.1 8% 1.8 -34%
3 1e9 68.0 42.0 62% 20.3 234% 98.1 -30%
4 1e7 0.1 0.0 87% 0.0 97% 0.0 67%
4 1e8 0.4 0.3 32% 0.3 36% 0.3 10%
4 1e9 34.3 32.6 5% 51.2 -32% 60.2 -43%
5 1e7 0.1 0.1 26% 0.1 24% 0.1 15%
5 1e8 1.1 1.1 6% 1.1 8% 1.5 -25%
5 1e9 17.7 15.6 13% 31.7 -43% 39.2 -54%
6 1e7 0.2 0.2 10% 0.5 -51%
6 1e8 1.2 1.1 12% 1.1 14%
6 1e9 21.6 22.1 -2% 45.4 -52%
7 1e7 0.2 0.2 24% 0.4 -52%
7 1e8 1.2 1.2 -3% 1.1 5%
7 1e9 15.3 16.3 -5% 55.5 -72%
8 1e7 0.8 0.8 3% 0.9 -12%
8 1e8 7.1 7.2 -1% 6.9 2%
8 1e9 127.2 98.6 28% 125.4 1%
9 1e7 0.2 0.3 -29% 0.2 -21%
9 1e8 2.5 1.0 148% 1.0 143%
9 1e9 101.8 101.2 0% 109.8 -7%
10 1e7 2.6 1.3 102% 1.7 49%
10 1e8 21.0 11.9 75% 16.9 24%
10 1e9 1486.1
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 8.1 36.9 276% 85.1 250% 15.4 186%
1 1e1 27.8 13.6 78% 14.9 70% 40.7 15%
1 2e0 15.3 1.1 604% 10.5 188%
2 1e2 4.5 4.5 51% 3.4 58% 7.4 38%
2 1e1 12.4 7.0 59% 9.1 105% 7.1 34%
2 2e0 6.1 4.3 30% 4.3 118%
3 1e2 23.1 14.4 29% 7.2 72% 33.4 -22%
3 1e1 143.3 53.0 78% 83.0 42% 47.2 73%
3 2e0 162.9 51.4 80% 69.3 30%
4 1e2 11.6 11.0 41% 17.2 33% 20.2 11%
4 1e1 12.5 24.0 20% 24.5 16% 18.6 3%
4 2e0 11.7 29.7 41% 23.1 46%
5 1e2 6.3 5.6 15% 10.9 -3% 13.6 -21%
5 1e1 46.8 14.6 135% 15.6 133% 19.3 100%
5 2e0 82.3 22.7 90% 21.9 87%
6 1e2 7.7 7.8 6% 15.6 -29%
6 1e1 7.8 14.7 1% 14.4 24%
6 2e0 11.6 16.5 -4% 5.7 74%
7 1e2 5.6 5.9 5% 19.0 -39%
7 1e1 80.3 26.0 77% 25.9 85%
7 2e0 136.3 33.9 109% 34.4 96%
8 1e2 45.0 35.5 10% 44.4 -2%
8 1e1 90.7 31.3 77%
8 2e0 123.5 33.3 107%
9 1e2 34.8 34.2 39% 37.0 38%
9 1e1 13.6 25.2 20%
9 2e0 8.7 18.5 50%
10 1e2 503.2
10 1e1 473.2
10 2e0 435.3
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 0.5 0.3 25% 0.4 -1%
1e2 1e8 4.1 2.6 133% 3.1 126%
1e2 1e9 190.5
1e1 1e7 0.4 0.3 56% 0.3 81%
1e1 1e8 4.0 2.8 34% 3.2 29%
1e1 1e9 268.1
2e0 1e7 0.5 0.4 34% 0.4 62%
2e0 1e8 4.5 3.4 47% 4.2 70%
2e0 1e9 293.2
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 8.1 36.9 276% 85.1 250% 15.4 186%
1e2 2 4.5 4.5 51% 3.4 58% 7.4 38%
1e2 3 23.1 14.4 29% 7.2 72% 33.4 -22%
1e2 4 11.6 11.0 41% 17.2 33% 20.2 11%
1e2 5 6.3 5.6 15% 10.9 -3% 13.6 -21%
1e2 6 7.7 7.8 6% 15.6 -29%
1e2 7 5.6 5.9 5% 19.0 -39%
1e2 8 45.0 35.5 10% 44.4 -2%
1e2 9 34.8 34.2 39% 37.0 38%
1e2 10 503.2
1e1 1 27.8 13.6 78% 14.9 70% 40.7 15%
1e1 2 12.4 7.0 59% 9.1 105% 7.1 34%
1e1 3 143.3 53.0 78% 83.0 42% 47.2 73%
1e1 4 12.5 24.0 20% 24.5 16% 18.6 3%
1e1 5 46.8 14.6 135% 15.6 133% 19.3 100%
1e1 6 7.8 14.7 1% 14.4 24%
1e1 7 80.3 26.0 77% 25.9 85%
1e1 8 90.7 31.3 77%
1e1 9 13.6 25.2 20%
1e1 10 473.2
2e0 1 15.3 1.1 604% 10.5 188%
2e0 2 6.1 4.3 30% 4.3 118%
2e0 3 162.9 51.4 80% 69.3 30%
2e0 4 11.7 29.7 41% 23.1 46%
2e0 5 82.3 22.7 90% 21.9 87%
2e0 6 11.6 16.5 -4% 5.7 74%
2e0 7 136.3 33.9 109% 34.4 96%
2e0 8 123.5 33.3 107%
2e0 9 8.7 18.5 50%
2e0 10 435.3
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.5 0.3 25% 0.4 -1%
0 1e8 4.1 2.6 133% 3.1 126%
0 1e9 190.5
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.5 0.3 25% 0.4 -1%
0 1e8 4.1 2.6 133% 3.1 126%
0 1e9 190.5
1 1e7 0.4 0.3 38% 0.3 49%
1 1e8 4.0 2.5 162% 2.9 196%
1 1e9 163.9

join

join for clickhouse not yet implemented.

Details

Environment

Nodename: mr-dl11

Timings


Report was generated on: 2020-10-12 06:25:19 PDT.